package com.ruoyi.system.mapper;

import com.ruoyi.system.domain.*;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface SystemMapper {
    @Update("update express_basicsetting set minute=#{b.minute},codescanner=#{b.codescanner},jid=#{b.jid} where id=#{b.id} ")
    void update1(@Param("b") Basicsetting b);
    @Update("update express_collectset set qjmyxtime=#{c.qjmyxtime},srqjmyxqi=#{c.srqjmyxqi},srqjmddjs=#{c.srqjmddjs},srsjhmdjs=#{c.srsjhmdjs},smqjmddjs=#{c.smqjmddjs},gmkqdjs=#{c.gmkqdjs},qjcgzddjs=#{c.qjcgzddjs} where id=#{c.id}")
    void update2(@Param("c") Collectset c);
    @Update("update express_deliverysetup set smdltime=#{d.smdltime},sjhtime=#{d.sjhtime},sjhhang=#{d.sjhhang},srsjhmdjs=#{d.srsjhmdjs},gmdjs=#{d.gmdjs},sjhdlmmdjs=#{d.sjhdlmmdjs},zfdjs=#{d.zfdjs},pjcgzdzxdjs=#{d.pjcgzdzxdjs} where id=#{d.id}")
    void update3(@Param("d") Deliverysetup d);
    @Select("select * from express_basicsetting")
    Basicsetting getSystem1();
    @Select("select * from express_collectset")
    Collectset getSystem2();
    @Select("select * from express_deliverysetup")
    Deliverysetup getSystem3();
    @Select("select * from express_smartcounter")
    Smartcounter getSystem4();
    @Update("update express_smartcounter set first=#{s.first},second=#{s.second},thirdid=#{s.thirdid} where id=#{s.id}")
    void update4(@Param("s") Smartcounter s);
    @Select("select * from express_dropdownkey")
    List<Dropdownkey> getSystem6();
    @Select("select * from express_dropdownvalue where did=#{id} order by paixu")
    List<Dropdownvalue> change(@Param("id") Integer id);
    @Insert("insert into express_dropdownkey (zkey,ekey,status,beizhu) values (#{d.zkey},#{d.ekey},#{d.status},#{d.beizhu})")
    void tianjia(@Param("d") Dropdownkey d);
    @Update("update express_dropdownkey set zkey=#{d.zkey},ekey=#{d.ekey},status=#{d.status},beizhu=#{d.beizhu},value=#{d.value} where id=#{d.id}")
    void xiugai(@Param("d") Dropdownkey d);
    @Update("update express_dropdownvalue set value=#{d.value},evalue=#{d.evalue},status=#{d.status},paixu=#{d.paixu},did=#{d.did} where id=#{d.id}")
    void xiugai1(@Param("d") Dropdownvalue d);
    @Insert("insert into express_dropdownvalue (value,evalue,status,paixu,did) values( #{d.value},#{d.evalue},#{d.status},#{d.paixu},#{d.did} )")
    void tianjia1(@Param("d") Dropdownvalue d);
    @Select("select * from express_dropdownkey where id=#{did}")
    Dropdownkey cha(@Param("did") Integer did);
    @Select("select * from express_dropdownvalue where did=#{did} ")
    List<Dropdownvalue> cha2(@Param("did") Integer did);
}
